SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

/****** Objeto: vista dbo.wav_help    fecha de la secuencia de comandos: 02/11/2005 18:17:52 ******/

CREATE    VIEW [dbo].[wav_help]

AS

SELECT 
	*
FROM 
	wad_programas
JOIN 
	( SELECT 'A' AS tipo_id, 'Abm''s' AS tipo_descripcion
          UNION
          SELECT 'L', 'Listados'
          UNION
          SELECT 'P', 'Procesos'
          UNION
          SELECT 'C', 'Consultas'
          UNION
          SELECT 'R', 'Rutinas' ) AS tipos 
ON 
	tipos.tipo_id = wad_programas.tp_programa


GO
